2016-12-05 - 23923 - Spec - North America Retail Incoming Payments #FIIncomingPayments

SPECIFICATIONS


23923-Spec-North America Retail Incoming Payments


Purpose

North America Retail Incoming Payments

Admin Info

Purpose
 North America Retail Incoming Payments
Requested By
 Baiwa
Spec Created By
 Raghav
Spec Created Date
 05/18/2016
Spec QA by
 Raghav
Objects
 ZFI_RETAIL_PAYMENT_NA
ZFI_NACOM_CUS
ZFI_NACOM_PYMT
ZFI_NAPYMT
ZFI_NACOM_CUSS
TVDIR
TDDAT
ZFI_NACOM_PYMTS
Document Status
 Complete


Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 08
2
 Documentation
 08
3
 Development/ Config
 50
4
 Unit test in DEV
 20
5
 Unit test in QUA
 14
6
 Other activity

TOTAL
 100

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]


Documents

[Attach any document(s) received for the requirement(s)]
RTI Retail_Pro_9_XML_Files.pdf001005I1609021.xml001005R1609021.xml002001HS1609071.xml



Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any
1
 New XML files are received for incoming payments
 Jingsha
 09/08/2016
 File with HS has initially stopped
2
 Program should read the multiple files in one run
 Jingsha
 10/06/2016
3
 Program should also read the single file from the selection screen
 Jingsha
 12/05/2016
4
 Program screen input should have posting date
 Jingsha
 12/05/2016





Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

North America Retail incoming payments have to be done by custom program with the XML file.
XML snapshot.PNG

In Scope:

[List the activities to be included in scope]

Out of Scope:

[Out of scope activities]

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

NA retail incoming payments program should clear the customer invoices and return orders with the transaction F-28 and F-53

Create the new Z custom table to determine the retail customer with the store number and company code with the subsidiary number.
Company code
 Subsidary number
 Store ID
 Customer
 Currency










Create an new Z custom table to determine the GL account based on the payment type

Company code
 Payment method
 Card Name
 Field Tender type
 Further info
 GL account












New NA retail incoming payments program have to be developed as per the F-28 and F-53 and the logic to determine the field in SAP is as below.

Field in XML
 SAP Fields
 Logic to determine fields in SAP
File
 BKPF-XBLNR
 This should be in Reference field
File
 RF05A-SEL01
 Reference to pull document
File
 BKPF-BKTXT
 Field should be in document header text.
Identifier
 BSEG-SGTXT and RF05A-AUGTX
 To be in each item text field
Store_no
 RF05A-AGKON
 Store ID to pull customer from custom table ZFI_NACOM_CUS
sbs_no
 BKPF-BUKRS
 To pull the company code from subsidiary no. from custom table ZFI_NACOM_CUS
post_date
 BKPF-BUDAT
 Posting date
Amt
 BSEG-WRBTR
 If file name have 'I' then F-28 and if file name have 'R' then F-53 and Account type should be D and document type should be DZ
Tender_type
 RF05A-KONTO
 Payment type to pull GL account from custom table ZFI_NACOM_PYMT
crd_name
 RF05A-KONTO
 Payment type to pull GL account from custom table ZFI_NACOM_PYMT
2) NA retail incoming payments program should read the multiple file in single run from AL11 path /usr/sap/NED/RETAIL/NA/IN

Test Plan

[List test scenarios/cases to be executed here]

Program with posting date and single file selection.
Test ID
 Test Scenario
 Expected Results
FI-001
 Retail incoming payments with posting date in screen and with single selection file
 Retail incoming payments program should read single file as given and posting date should be from screen and document date should be from XML file
FI-002
 Retail incoming payments with posting date in screen and all files
 Retail incoming payments program should read all files in the directory path and posting date should be as given in screen and document date should be from XML file
FI-003
 Retail incoming payments without posting date and with single selection file
 Retail incoming payments program should read single file as given and posting date and document date should be from XML file
FI-004
 Retail incoming payments without posting date and all files
 Retail incoming payments program should read all files in the directory path and posting date and document date should be from XML file
Issues:
1) Before getting the input file signature_map field should be empty/ romove the long length.
2) Program should read the amount field from item INVC_TENDER amt field and all other amt field should be restricted from the XML file.
3) Program should not delete the lines with the same tender type and should calculate and post in payment document

Solution Details

[Provide complete technical details for configuration or programming here]

New program ZFI_RETAIL_PAYMENT_NA is developed to read XML file from desktop/application server.
After reading XML file we have listed required fields. Based on required fields we are passing data to F-28 & F-53 to post invoice.


Issues

[List Issues / Bugs identified in configuration or development]
1) Input XML file getting the field signature_map with very long length cause unable to read the file.
2) XML file also have value in "INVC_FEE amt" field
3) Programming is ommiting the repeated tender type lines from the file.